namespace Forging2.DataBase.ZH_IMES
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class umpp_plan_order
    {
        [Key]
        [StringLength(50)]
        public string GID { get; set; }

        [StringLength(200)]
        public string CODE { get; set; }

        public int? TYPE { get; set; }

        public int? PRIORITY { get; set; }

        public int? STATE { get; set; }

        [StringLength(128)]
        public string SITE_CODE { get; set; }

        [StringLength(50)]
        public string WORK_CENTER_GID { get; set; }

        [StringLength(50)]
        public string STORE_CODE { get; set; }

        [StringLength(50)]
        public string PARENT_ID { get; set; }

        [StringLength(50)]
        public string SPLIT_ID { get; set; }

        public int? SEQ { get; set; }

        [StringLength(50)]
        public string SALES_ORDER_CODE { get; set; }

        [StringLength(50)]
        public string PRODU_CODE { get; set; }

        [StringLength(100)]
        public string PRODU_NAME { get; set; }

        public int? PRODU_TYPE { get; set; }

        public int? DECOMPOSE_STATE { get; set; }

        public DateTime? PLANNED_BEGIN_DATE { get; set; }

        public DateTime? PLANNED_END_DATE { get; set; }

        public DateTime? DUE_DATE { get; set; }

        public DateTime? ASSIGN_DATE { get; set; }

        [StringLength(50)]
        public string ROUTE_GID { get; set; }

        public int? BOM_STATE { get; set; }

        public int? BOM_TYPE { get; set; }

        [StringLength(50)]
        public string BOM_CODE { get; set; }

        [StringLength(50)]
        public string SOURCE_TYPE { get; set; }

        public int? BOM_VERSION { get; set; }

        public int? ROUTE_VERSION { get; set; }

        [StringLength(128)]
        public string DRAWING_VERSION { get; set; }

        public int? SCHEDULE_STATE { get; set; }

        public int? NATURE { get; set; }

        public int? PRO_TYPE { get; set; }

        [StringLength(200)]
        public string REMARK { get; set; }

        [StringLength(50)]
        public string SAP_ORDER_TYPE { get; set; }

        [StringLength(50)]
        public string PLAN_ORDER_TYPE { get; set; }

        [StringLength(50)]
        public string TO_SITE { get; set; }

        [StringLength(50)]
        public string PRODU_PLANER { get; set; }

        [StringLength(50)]
        public string MRP_CONTROLLER { get; set; }

        [StringLength(50)]
        public string MEASURE { get; set; }

        public decimal? RECEIVE_QTY { get; set; }

        [StringLength(50)]
        public string SALES_OF_BOUND_CODE { get; set; }

        [StringLength(50)]
        public string SALES_OF_BOUND_LINE_CODE { get; set; }

        public int? SYNC_RESULT { get; set; }

        [StringLength(50)]
        public string SYNC_REASON { get; set; }

        [StringLength(50)]
        public string PLNNR { get; set; }

        [StringLength(1)]
        public string PLNAL { get; set; }

        public int? MATERIAL_STATE { get; set; }

        [StringLength(50)]
        public string QUALITY { get; set; }

        [StringLength(50)]
        public string MES_LOT_CODE { get; set; }

        [StringLength(50)]
        public string SAP_LOT_CODE { get; set; }

        public int? QTY { get; set; }

        public int? SPLIT_QTY { get; set; }

        [StringLength(50)]
        public string PROCESS_LINE_GID { get; set; }

        [Required]
        [StringLength(32)]
        public string CREATE_ID { get; set; }

        public DateTime CREATE_DATE { get; set; }

        [StringLength(32)]
        public string MODIFY_ID { get; set; }

        public DateTime? MODIFY_DATE { get; set; }

        public decimal IS_ACTIVE { get; set; }

        public decimal IS_DELETE { get; set; }

        [StringLength(50)]
        public string SITE { get; set; }

        [StringLength(50)]
        public string UDA1 { get; set; }

        [StringLength(50)]
        public string UDA2 { get; set; }

        [StringLength(50)]
        public string UDA3 { get; set; }

        [StringLength(50)]
        public string UDA4 { get; set; }

        [StringLength(50)]
        public string UDA5 { get; set; }

        [StringLength(100)]
        public string UDA1C { get; set; }

        [StringLength(100)]
        public string UDA1N { get; set; }

        [StringLength(100)]
        public string UDA2C { get; set; }

        [StringLength(100)]
        public string UDA2N { get; set; }

        [StringLength(100)]
        public string UDA3C { get; set; }

        [StringLength(100)]
        public string UDA3N { get; set; }

        [StringLength(100)]
        public string UDA4C { get; set; }

        [StringLength(100)]
        public string UDA4N { get; set; }

        [StringLength(100)]
        public string UDA5C { get; set; }

        [StringLength(100)]
        public string UDA5N { get; set; }

        [StringLength(50)]
        public string UDA6 { get; set; }

        [Column(TypeName = "date")]
        public DateTime? ERP_MODIFY_DATE { get; set; }

        [StringLength(50)]
        public string UDA7 { get; set; }

        [StringLength(50)]
        public string UDA8 { get; set; }

        [StringLength(50)]
        public string UDA9 { get; set; }

        [StringLength(50)]
        public string UDA10 { get; set; }
    }
}
